
  CREATE TABLE "MOBILE"."ODS_CUS_BASE" 
   (	"C_CUS_NO" VARCHAR2(20), 
	"C_CUS_NME" VARCHAR2(200), 
	"C_CUS_TEL" VARCHAR2(15), 
	"C_CUS_MOBILE" VARCHAR2(20), 
	"C_CUS_TYP" VARCHAR2(5), 
	"C_CUS_SEX" VARCHAR2(1), 
	"C_CUS_MAIL" VARCHAR2(30), 
	"C_CUS_MOBILE1" VARCHAR2(12), 
	"C_CUS_RELNAME" VARCHAR2(50), 
	"C_EMP_CDE" VARCHAR2(20), 
	"C_AGENT_CDE" VARCHAR2(50), 
	"C_CUS_QQ" VARCHAR2(15), 
	"C_CUS_WECHAT" VARCHAR2(20), 
	"C_CUS_AREA" VARCHAR2(20), 
	"C_CUS_NEWFLAG" VARCHAR2(5), 
	"C_CUS_FLAG" VARCHAR2(5), 
	"C_CUS_IMAGE" VARCHAR2(5)
   ) 
   
   
   
  CREATE TABLE "MOBILE"."ODS_CUS_CARINFO" 
   (	"C_CUS_NO" VARCHAR2(50), 
	"C_CAR_MODEL" VARCHAR2(100), 
	"C_CAR_PRICE" NUMBER(10,2), 
	"C_CAR_NO" VARCHAR2(50), 
	"C_FRM_FLG" VARCHAR2(1), 
	"C_CAR_VIN" VARCHAR2(50), 
	"C_CAR_ENGINE" VARCHAR2(50), 
	"C_CAR_PLATE" VARCHAR2(20), 
	"C_FST_REG_YM" VARCHAR2(50), 
	"N_SEAT_NUM" NUMBER(4,0), 
	"N_TONAGE" NUMBER(20,6), 
	"C_CAR_AGE" NUMBER(2,0), 
	"C_PLY_SY" VARCHAR2(50), 
	"C_PLY_JQ" VARCHAR2(50), 
	"C_CAR_USAGE" VARCHAR2(10), 
	"C_CAR_KIND" VARCHAR2(10), 
	"C_CAR_IMAGE" VARCHAR2(5)
   ) 
   
   
   
  CREATE TABLE "MOBILE"."ODS_CUS_CERTINFO" 
   (	"C_CUS_NO" VARCHAR2(50), 
	"C_CERT_TPY" VARCHAR2(50), 
	"C_CERT_NO" VARCHAR2(50), 
	"T_CERT_ISSUEDATE" DATE, 
	"T_CERT_EFFECDATE" DATE
   ) 
   
   
  CREATE TABLE "MOBILE"."ODS_PLY_BASE" 
   (	"C_CUS_NO" VARCHAR2(50), 
	"C_PLY_NO" VARCHAR2(100), 
	"N_PLY_PRM" NUMBER(20,2), 
	"C_PLY_STS" VARCHAR2(10), 
	"C_PROD_NO" VARCHAR2(10), 
	"T_INS_BGN_TM" DATE, 
	"T_INS_END_TM" DATE, 
	"C_PLATE_NO" VARCHAR2(50), 
	"C_ENG_NO" VARCHAR2(50), 
	"C_FRM_NO" VARCHAR2(50), 
	"C_CAR_MODEL" VARCHAR2(100), 
	"T_APP_TM" DATE, 
	"C_CUS_NME" VARCHAR2(200), 
	"C_DPT_CDE" VARCHAR2(10), 
	"C_CONFER_NO" VARCHAR2(20), 
	"N_SUB_CONFER_NO" NUMBER(4,0)
   ) 
   
   
   
  CREATE TABLE "MOBILE"."ODS_PLY_CVRG" 
   (	"C_PK_ID" VARCHAR2(300 CHAR) NOT NULL ENABLE, 
	"C_APP_NO" VARCHAR2(50 CHAR) NOT NULL ENABLE, 
	"C_ROW_ID" VARCHAR2(300 CHAR), 
	"C_PLY_NO" VARCHAR2(50 CHAR), 
	"N_EDR_PRJ_NO" NUMBER(6,0), 
	"C_EDR_NO" VARCHAR2(50), 
	"N_SEQ_NO" NUMBER(6,0) DEFAULT 1 NOT NULL ENABLE, 
	"C_CVRG_NO" VARCHAR2(200 CHAR), 
	"C_CUST_CVRG_NME" VARCHAR2(200 CHAR), 
	"C_CUST_CL_CTNT" VARCHAR2(3999 CHAR), 
	"N_AMT" NUMBER(20,2), 
	"N_RATE" NUMBER(20,6), 
	"N_BASE_PRM" NUMBER(20,2) DEFAULT 0, 
	"N_BEF_PRM" NUMBER(20,2), 
	"N_DIS_COEF" NUMBER(10,6) DEFAULT 1, 
	"N_CALC_PRM" NUMBER(20,2), 
	"N_PRM" NUMBER(20,2), 
	"N_BEF_ANN_PRM" NUMBER(20,2), 
	"N_CALC_ANN_PRM" NUMBER(20,2), 
	"T_PRM_CHG_TM" DATE, 
	"N_DUT_PRM" NUMBER(20,2), 
	"C_REMARK" VARCHAR2(3999 CHAR), 
	"C_TGT_TYP" VARCHAR2(30 CHAR), 
	"C_TGT_NME" VARCHAR2(200 CHAR), 
	"N_TGT_QTY" NUMBER(8,0), 
	"N_INDEM_LMT" NUMBER(20,2), 
	"C_DDUCT_MRK" VARCHAR2(30 CHAR) DEFAULT '0', 
	"N_DDUCT_RATE" NUMBER(10,6), 
	"C_DDUCT_DESC" VARCHAR2(200 CHAR), 
	"N_DDUCT_AMT" NUMBER(20,2), 
	"C_CANCEL_MRK" CHAR(1 CHAR), 
	"C_INDEM_LMT_LVL" VARCHAR2(200 CHAR), 
	"N_LIAB_DAYS_LMT" NUMBER(20,6), 
	"N_PER_AMT" NUMBER(20,2), 
	"N_PER_INDEM_LMT" NUMBER(20,2), 
	"N_PER_PRM" NUMBER(20,2), 
	"N_ONCE_INDEM_LMT" NUMBER(20,2), 
	"N_SAVING_AMT" NUMBER(20,2), 
	"T_BGN_TM" DATE, 
	"T_END_TM" DATE, 
	"N_AMT_VAR" NUMBER(20,2), 
	"N_PRM_VAR" NUMBER(20,2), 
	"N_CALC_PRM_VAR" NUMBER(20,2), 
	"N_INDEM_VAR" NUMBER(20,2), 
	"C_LATEST_MRK" VARCHAR2(30 CHAR), 
	"C_CRT_CDE" VARCHAR2(30 CHAR) NOT NULL ENABLE, 
	"T_CRT_TM" DATE NOT NULL ENABLE, 
	"C_UPD_CDE" VARCHAR2(30 CHAR) NOT NULL ENABLE, 
	"T_UPD_TM" DATE NOT NULL ENABLE, 
	"C_RESV_TXT_1" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_2" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_3" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_4" VARCHAR2(2000 CHAR), 
	"C_RESV_TXT_5" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_6" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_7" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_8" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_9" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_10" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_11" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_12" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_13" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_14" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_15" VARCHAR2(3999 CHAR), 
	"C_RESV_TXT_16" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_17" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_18" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_19" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_20" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_21" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_22" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_23" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_24" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_25" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_26" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_27" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_28" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_29" VARCHAR2(200 CHAR), 
	"C_RESV_TXT_30" VARCHAR2(200 CHAR), 
	"N_RESV_NUM_1" NUMBER(20,6), 
	"N_RESV_NUM_2" NUMBER(20,6), 
	"N_RESV_NUM_3" NUMBER(20,6), 
	"N_RESV_NUM_4" NUMBER(20,6), 
	"N_RESV_NUM_5" NUMBER(20,6), 
	"N_RESV_NUM_6" NUMBER(20,6), 
	"N_RESV_NUM_7" NUMBER(20,6), 
	"N_RESV_NUM_8" NUMBER(20,6), 
	"N_RESV_NUM_9" NUMBER(20,6), 
	"N_RESV_NUM_10" NUMBER(20,6), 
	"N_RESV_NUM_11" NUMBER(20,6), 
	"N_RESV_NUM_12" NUMBER(20,6), 
	"N_RESV_NUM_13" NUMBER(20,6), 
	"N_RESV_NUM_14" NUMBER(20,6), 
	"N_RESV_NUM_15" NUMBER(20,6), 
	"N_RESV_NUM_16" NUMBER(20,6), 
	"N_RESV_NUM_17" NUMBER(20,6), 
	"N_RESV_NUM_18" NUMBER(20,6), 
	"N_RESV_NUM_19" NUMBER(20,6), 
	"N_RESV_NUM_20" NUMBER(20,6), 
	"N_RESV_NUM_21" NUMBER(20,6), 
	"N_RESV_NUM_22" NUMBER(20,6), 
	"N_RESV_NUM_23" NUMBER(20,6), 
	"N_RESV_NUM_24" NUMBER(20,6), 
	"N_RESV_NUM_25" NUMBER(20,6), 
	"N_RESV_NUM_26" NUMBER(20,6), 
	"N_RESV_NUM_27" NUMBER(20,6), 
	"N_RESV_NUM_28" NUMBER(20,6), 
	"N_RESV_NUM_29" NUMBER(20,6), 
	"N_RESV_NUM_30" NUMBER(20,6), 
	"T_RESV_TM_1" DATE, 
	"T_RESV_TM_2" DATE, 
	"T_RESV_TM_3" DATE, 
	"T_RESV_TM_4" DATE, 
	"T_RESV_TM_5" DATE, 
	"C_TRANS_MRK" CHAR(1 CHAR), 
	"T_TRANS_TM" DATE, 
	"N_DDUCT_PRM" NUMBER(20,2), 
	"C_UNDER_INSURANCE_FLAG" VARCHAR2(30 CHAR), 
	"C_CVRG_NO_OLD" VARCHAR2(8 CHAR), 
	"N_FLOAT_RATE" NUMBER(20,6), 
	"N_EXEM_PERIOD" NUMBER(6,0), 
	"C_PLAN_NO" VARCHAR2(50 CHAR), 
	"C_INSRNC_MRK" VARCHAR2(4 CHAR), 
	"C_TGT_OBJ_CDE" VARCHAR2(10 CHAR), 
	"N_EDR_PRM" NUMBER(20,2), 
	"C_SYS_SRC" VARCHAR2(2)
   ) 
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_PK_ID" IS 'PKID'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_APP_NO" IS '申请单号'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_ROW_ID" IS '记录唯一标识号,投保时为投保单的PKID，批改申请时如非新增记录则为原投保单的PKID，如为新增记录则为批改申请单的PKID'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_PLY_NO" IS '保单号,保单号 Policy No'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_EDR_PRJ_NO" IS '批改序号,批改次数 Times of Endorsement'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_EDR_NO" IS '批单号'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_SEQ_NO" IS '序号,序号 Sequence No'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_CVRG_NO" IS '险别（扩展条款）编号,险别（扩展条款）编号 Coverage Code'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_CUST_CVRG_NME" IS '自定义险别名称,自定义险别名称 Customized Coverage Name'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_CUST_CL_CTNT" IS '自定义条款内容,自定义条款内容 Customized Clause Content'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_AMT" IS '保额,保额 Amount Insured'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RATE" IS '费率,费率 Premium Rate'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_BASE_PRM" IS '基本保费,基本保费 Base Premium'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_BEF_PRM" IS '折前保费,折前保费 Premium without Discount'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_DIS_COEF" IS '折扣系数,优惠系数 Discount Coefficient'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_CALC_PRM" IS '折后保费,计算保费 Calculated Premium'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_PRM" IS '实际保费,保费 Premium'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_BEF_ANN_PRM" IS '年折前保费,年折前保费 Annual Premium without Discount'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_CALC_ANN_PRM" IS '年折后保费,年计算保费 Calculated Annual Premium'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_PRM_CHG_TM" IS '保费变化时间,保费变化时间，缺省为保单起保日期'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_DUT_PRM" IS '变化前已了责任保费,已了责任保费，缺省为0'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_REMARK" IS '备注,备注 Remark'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_TGT_TYP" IS '标的类型代码,标的类型代码 Subject-matter Type'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_TGT_NME" IS '标的名称,标的名称 Subject-matter Name'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_TGT_QTY" IS '标的数量,标的数量 Quantity of Subject-matters'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_INDEM_LMT" IS '赔偿限额,赔偿限额 Indemnity Limit'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_DDUCT_MRK" IS '不计免赔标志,''0'' 否,''1'' 是'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_DDUCT_RATE" IS '免赔率,免赔率 Deductable Rate'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_DDUCT_DESC" IS '免赔说明,免赔说明 Deductable Description'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_DDUCT_AMT" IS '绝对免赔额,绝对免赔额 Straight Deductible Amount'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_CANCEL_MRK" IS '退保标志,退保标志 Cancel Flag，缺省为''1''，当批改退保时为‘0’'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_INDEM_LMT_LVL" IS '赔偿限额档次,赔偿限额档次(车险) Level of Indemnity Limit,起付限额[063013产品]'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_LIAB_DAYS_LMT" IS '责任天数,责任时限(车险) Days Limit of Liability车上人员责任险作为乘客座位数'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_PER_AMT" IS '每标的保额,每标的保额  Amount for Each Subject-matter车上人员责任险作为司机保额'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_PER_INDEM_LMT" IS '每标的赔偿限额,每标的赔偿限额 Indemnity Limit for Each Subject-matter车上人员责任险作为乘客保额'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_PER_PRM" IS '每标的保费,每标的保费 Premium for Each Subject-matter'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_ONCE_INDEM_LMT" IS '单次赔偿限额,单次赔偿限额 Indemnity Limit for Any One Claim'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_SAVING_AMT" IS '储金,储金 Amount of Saving Fund'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_BGN_TM" IS '有效起期,险别的有效起期，保单为保单的保险起期，批单为批单的生效起期'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_END_TM" IS '有效止期,险别的有效起期，保单为保单的保险止期，批单为批单的生效止期'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_AMT_VAR" IS '保额变化'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_PRM_VAR" IS '保费变化'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_CALC_PRM_VAR" IS '计算保费变化,计算保费 Calculated Premium'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_INDEM_VAR" IS '赔偿限额变化'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_LATEST_MRK" IS '最新保单标志,''0''否,''1''是'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_CRT_CDE" IS '创建人代码'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_CRT_TM" IS '创建时间'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_UPD_CDE" IS '修改人代码'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_UPD_TM" IS '修改时间'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_1" IS '预留字符串字段1,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_2" IS '预留字符串字段2,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_3" IS '预留字符串字段3,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_4" IS '预留字符串字段4,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_5" IS '预留字符串字段5,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_6" IS '预留字符串字段6,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_7" IS '预留字符串字段7,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_8" IS '预留字符串字段8,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_9" IS '预留字符串字段9,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_10" IS '预留字符串字段10,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_11" IS '预留字符串字段11,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_12" IS '预留字符串字段12,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_13" IS '预留字符串字段13,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_14" IS '预留字符串字段14,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_15" IS '预留字符串字段15,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_16" IS '预留字符串字段16,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_17" IS '预留字符串字段17,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_18" IS '预留字符串字段18,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_19" IS '预留字符串字段19,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_20" IS '预留字符串字段20,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_21" IS '预留字符串字段21,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_22" IS '预留字符串字段22,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_23" IS '预留字符串字段23,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_24" IS '预留字符串字段24,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_25" IS '预留字符串字段25,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_26" IS '预留字符串字段26,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_27" IS '预留字符串字段27,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_28" IS '预留字符串字段28,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_29" IS '预留字符串字段29,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_RESV_TXT_30" IS '预留字符串字段30,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_1" IS '预留数值字段1,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_2" IS '预留数值字段2,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_3" IS '预留数值字段3,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_4" IS '预留数值字段4,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_5" IS '预留数值字段5,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_6" IS '预留数值字段6,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_7" IS '预留数值字段7,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_8" IS '预留数值字段8,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_9" IS '预留数值字段9,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_10" IS '预留数值字段10,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_11" IS '预留数值字段11,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_12" IS '预留数值字段12,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_13" IS '预留数值字段13,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_14" IS '预留数值字段14,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_15" IS '预留数值字段15,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_16" IS '预留数值字段16,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_17" IS '预留数值字段17,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_18" IS '预留数值字段18,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_19" IS '预留数值字段19,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_20" IS '预留数值字段20,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_21" IS '预留数值字段21,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_22" IS '预留数值字段22,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_23" IS '预留数值字段23,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_24" IS '预留数值字段24,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_25" IS '预留数值字段25,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_26" IS '预留数值字段26,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_27" IS '预留数值字段27,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_28" IS '预留数值字段28,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_29" IS '预留数值字段29,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_RESV_NUM_30" IS '预留数值字段30,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_RESV_TM_1" IS '预留时间字段1,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_RESV_TM_2" IS '预留时间字段2,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_RESV_TM_3" IS '预留时间字段3,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_RESV_TM_4" IS '预留时间字段4,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_RESV_TM_5" IS '预留时间字段5,预留'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_TRANS_MRK" IS '迁移标志'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."T_TRANS_TM" IS '迁移时间'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_DDUCT_PRM" IS '不计免赔保费'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_UNDER_INSURANCE_FLAG" IS '不足额投保标志:0:足额投保,1:不足额投保'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_CVRG_NO_OLD" IS '老系统险别代码'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_FLOAT_RATE" IS '浮动率'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_EXEM_PERIOD" IS '免责期（天）'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_PLAN_NO" IS '方案号'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_INSRNC_MRK" IS '意外险种类型'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."C_TGT_OBJ_CDE" IS '投保方式'
   COMMENT ON COLUMN "MOBILE"."ODS_PLY_CVRG"."N_EDR_PRM" IS '批单保费'
   COMMENT ON TABLE "MOBILE"."ODS_PLY_CVRG"  IS '保单险别信息'
   -- 统计sql
   SELECT RPT_OPERATOR_ID, AVG(RPT_OPERATION_TIME_TOTAL) AS AVG_TOTAL FROM JBA_RECEIPT_DETAIL GROUP BY RPT_OPERATOR_ID ORDER BY AVG(RPT_OPERATION_TIME_TOTAL) DESC
   
   
--报案信息表创建
/*
Navicat Oracle Data Transfer
Oracle Client Version : 10.2.0.5.0

Source Server         : 113
Source Server Version : 110200
Source Host           : 10.0.0.101:1521
Source Schema         : ACBA

Target Server Type    : ORACLE
Target Server Version : 110200
File Encoding         : 65001

Date: 2014-07-21 20:28:52
*/


-- ----------------------------
-- Table structure for JBA_RECEIPT_DETAIL
-- ----------------------------
DROP TABLE "ACBA"."JBA_RECEIPT_DETAIL";
CREATE TABLE "ACBA"."JBA_RECEIPT_DETAIL" (
"ID" NUMBER(8) NOT NULL , --编号
"RPT_REPORTER" VARCHAR2(50 BYTE) NULL ,--报案人
"RPT_REPORTER_PHONE" VARCHAR2(50 BYTE) NULL ,--报案人电话
"RPT_CONTACT" VARCHAR2(50 BYTE) NULL ,--联系人
"RPT_CONTACT_PHONE" VARCHAR2(50 BYTE) NULL ,--联系人电话
"RPT_CAR_NO" VARCHAR2(50 BYTE) NULL ,--车号
"RPT_INVOLVED_CAR_NUM" NUMBER(8) NULL ,--受损车辆数
"RPT_MATERIALS_DESTROY_FLAG" CHAR(1 BYTE) NULL ,--物品损失标识  1有0无
"RPT_DEAD_NUM" NUMBER(8) NULL , --死亡人数
"RPT_INJURY_NUM" NUMBER(8) NULL ,--受伤人数
"RPT_SINGLE_CAR_FLAG" CHAR(1 BYTE) NULL ,--单车事故标识 1是0无
"RPT_OCCUR_TIME" DATE NULL ,--出险时间
"RPT_REPORT_TIME" DATE NULL ,--报案时间
"RPT_OCCUR_ADDR" VARCHAR2(200 BYTE) NULL ,--出险地点
"RPT_OCCUR_PROVINCE" VARCHAR2(20 BYTE) NULL ,--出险所在地省份
"RPT_OCCUR_CITY" VARCHAR2(20 BYTE) NULL ,--出险所在地城市
"RPT_OCCUR_AREA" VARCHAR2(20 BYTE) NULL ,--出险所在地地区
"RPT_OCCUR_LNGT" NUMBER(15,10) NULL ,--出险所在地经度
"RPT_OCCUR_LATT" NUMBER(15,10) NULL ,--出险所在地纬度
"RPT_CHECK_ADDR" VARCHAR2(200 BYTE) NULL ,--查勘地点
"RPT_CHECK_PROVINCE" VARCHAR2(20 BYTE) NULL ,--查勘所在地省份
"RPT_CHECK_CITY" VARCHAR2(20 BYTE) NULL ,--查勘所在地城市
"RPT_CHECK_AREA" VARCHAR2(20 BYTE) NULL ,--查勘所在地地区
"RPT_CHECK_LNGT" NUMBER(15,10) NULL ,--查勘所在地经度
"RPT_CHECK_LATT" NUMBER(15,10) NULL ,--查勘所在地纬度
"RPT_DESCRIPTION" VARCHAR2(200 BYTE) NULL ,--出险经过
"RPT_REASON" VARCHAR2(200 BYTE) NULL ,--出险原因
"RPT_HUGE_DISASTER_FLAG" CHAR(1 BYTE) NULL ,--巨灾标识  1是0否
"RPT_AGENT_CLAIM_FLAG" CHAR(1 BYTE) NULL ,--代位求偿标识 1是0否
"RPT_VALID_TRA_PLY_NO" VARCHAR2(200 BYTE) NULL ,--涉案交强险保单号
"RPT_VALID_BIZ_PLY_NO" VARCHAR2(200 BYTE) NULL ,--涉案商业险保单号
"RPT_AVAILABLE_FLAG" CHAR(1 BYTE) NULL ,--报案有效标志 1有效0无效
"RPT_RECODE_CODE" VARCHAR2(50 BYTE) NULL ,--报案录音编号
"RPT_OPERATOR_ID" VARCHAR2(50 BYTE) NULL ,--接案人员编号
"RPT_OPERATION_TIME" NUMBER(16) NULL ,--接案耗时 电话打进到提交的耗时 单位毫秒
"RPT_OPERATION_TIME_TOTAL" NUMBER(16) NULL ,--接案总耗时 电话打进到成功提交的耗时 单位毫秒
"RPT_OPERATION_TIME_MORE" NUMBER(16) NULL --接案处理保单信息耗时 正常报案车牌无法获取保单信息,根据更多信息查询保单信息的耗时 单位毫秒
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Indexes structure for table JBA_RECEIPT_DETAIL
-- ----------------------------

-- ----------------------------
-- Triggers structure for table JBA_RECEIPT_DETAIL 
-- ----------------------------
CREATE OR REPLACE TRIGGER "ACBA"."JBA_RECEIPT_DETAIL_ID_ST" BEFORE INSERT ON "ACBA"."JBA_RECEIPT_DETAIL" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW ENABLE
BEGIN  SELECT jba_receipt_detail_id_seq.nextval into :new.id FROM dual; END jba_receipt_detail_id_ST; --ID Trigger
-- ----------------------------
-- Checks structure for table JBA_RECEIPT_DETAIL
-- ----------------------------
ALTER TABLE "ACBA"."JBA_RECEIPT_DETAIL" ADD CHECK (rpt_materials_destroy_flag in(0,1));-- boolen value check
ALTER TABLE "ACBA"."JBA_RECEIPT_DETAIL" ADD CHECK (rpt_single_car_flag in(0,1));-- boolen value check
ALTER TABLE "ACBA"."JBA_RECEIPT_DETAIL" ADD CHECK (rpt_huge_disaster_flag in(0,1));-- boolen value check
ALTER TABLE "ACBA"."JBA_RECEIPT_DETAIL" ADD CHECK (rpt_agent_claim_flag in(0,1));-- boolen value check
ALTER TABLE "ACBA"."JBA_RECEIPT_DETAIL" ADD CHECK (rpt_available_flag in(0,1));-- boolen value check

-- ----------------------------
-- Primary Key structure for table JBA_RECEIPT_DETAIL
-- ----------------------------
ALTER TABLE "ACBA"."JBA_RECEIPT_DETAIL" ADD PRIMARY KEY ("ID"); --PK
